1) Select all data
2) Insert PivotTable
3) Select Field
a) "One Colunm" to Row Labels
b) "Another Colunm" Move to Values, and Value Field Settings to "Average"
2) Insert PivotTable
3) Select Field
a) "One Colunm" to Row Labels
b) "Another Colunm" Move to Values, and Value Field Settings to "Average"